﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="INVE_FISHDataSet" targetNamespace="http://tempuri.org/INVE_FISHDataSet.xsd" xmlns:mstns="http://tempuri.org/INVE_FISHDataSet.xsd" xmlns="http://tempuri.org/INVE_FISHDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="INVE_FISHConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="INVE_FISHConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MonografiaV1._0.My.MySettings.GlobalReference.Default.INVE_FISHConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AccesoTableAdapter" GeneratorDataComponentClassName="AccesoTableAdapter" Name="Acceso" UserDataComponentName="AccesoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Acceso" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Acceso] WHERE (([ID_Usuario] = @Original_ID_Usuario) AND ((@IsNull_Usuario = 1 AND [Usuario] IS NULL) OR ([Usuario] = @Original_Usuario)) AND ((@IsNull_Contrasenia = 1 AND [Contrasenia] IS NULL) OR ([Contrasenia] = @Original_Contrasenia)) AND ((@IsNull_ID_Rol = 1 AND [ID_Rol] IS NULL) OR ([ID_Rol] = @Original_ID_Rol)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Usuario" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contrasenia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contrasenia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Acceso] ([ID_Usuario], [Usuario], [Contrasenia], [ID_Rol]) VALUES (@ID_Usuario, @Usuario, @Contrasenia, @ID_Rol);
SELECT ID_Usuario, Usuario, Contrasenia, ID_Rol FROM Acceso WHERE (ID_Usuario = @ID_Usuario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Usuario" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contrasenia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Usuario, Usuario, Contrasenia, ID_Rol FROM dbo.Acceso</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Acceso] SET [ID_Usuario] = @ID_Usuario, [Usuario] = @Usuario, [Contrasenia] = @Contrasenia, [ID_Rol] = @ID_Rol WHERE (([ID_Usuario] = @Original_ID_Usuario) AND ((@IsNull_Usuario = 1 AND [Usuario] IS NULL) OR ([Usuario] = @Original_Usuario)) AND ((@IsNull_Contrasenia = 1 AND [Contrasenia] IS NULL) OR ([Contrasenia] = @Original_Contrasenia)) AND ((@IsNull_ID_Rol = 1 AND [ID_Rol] IS NULL) OR ([ID_Rol] = @Original_ID_Rol)));
SELECT ID_Usuario, Usuario, Contrasenia, ID_Rol FROM Acceso WHERE (ID_Usuario = @ID_Usuario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Usuario" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contrasenia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Usuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Usuario" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Usuario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contrasenia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contrasenia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contrasenia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Usuario" DataSetColumn="ID_Usuario" />
              <Mapping SourceColumn="Usuario" DataSetColumn="Usuario" />
              <Mapping SourceColumn="Contrasenia" DataSetColumn="Contrasenia" />
              <Mapping SourceColumn="ID_Rol" DataSetColumn="ID_Rol" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BodegasTableAdapter" GeneratorDataComponentClassName="BodegasTableAdapter" Name="Bodegas" UserDataComponentName="BodegasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Bodegas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Bodegas] WHERE (([ID_Bodega] = @Original_ID_Bodega) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_ID_Tipo_Bodega = 1 AND [ID_Tipo_Bodega] IS NULL) OR ([ID_Tipo_Bodega] = @Original_ID_Tipo_Bodega)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Bodegas] ([ID_Bodega], [Descripcion], [ID_Tipo_Bodega]) VALUES (@ID_Bodega, @Descripcion, @ID_Tipo_Bodega);
SELECT ID_Bodega, Descripcion, ID_Tipo_Bodega FROM Bodegas WHERE (ID_Bodega = @ID_Bodega)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Bodega, Descripcion, ID_Tipo_Bodega FROM dbo.Bodegas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Bodegas] SET [ID_Bodega] = @ID_Bodega, [Descripcion] = @Descripcion, [ID_Tipo_Bodega] = @ID_Tipo_Bodega WHERE (([ID_Bodega] = @Original_ID_Bodega) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_ID_Tipo_Bodega = 1 AND [ID_Tipo_Bodega] IS NULL) OR ([ID_Tipo_Bodega] = @Original_ID_Tipo_Bodega)));
SELECT ID_Bodega, Descripcion, ID_Tipo_Bodega FROM Bodegas WHERE (ID_Bodega = @ID_Bodega)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Bodega" DataSetColumn="ID_Bodega" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="ID_Tipo_Bodega" DataSetColumn="ID_Tipo_Bodega" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InventarioTableAdapter" GeneratorDataComponentClassName="InventarioTableAdapter" Name="Inventario" UserDataComponentName="InventarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Inventario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Inventario] WHERE (([ID_Inventario] = @Original_ID_Inventario) AND ((@IsNull_Cantidad = 1 AND [Cantidad] IS NULL) OR ([Cantidad] = @Original_Cantidad)) AND ((@IsNull_ID_Producto = 1 AND [ID_Producto] IS NULL) OR ([ID_Producto] = @Original_ID_Producto)) AND ((@IsNull_ID_Movimientos = 1 AND [ID_Movimientos] IS NULL) OR ([ID_Movimientos] = @Original_ID_Movimientos)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Inventario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Inventario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Inventario] ([ID_Inventario], [Cantidad], [ID_Producto], [ID_Movimientos]) VALUES (@ID_Inventario, @Cantidad, @ID_Producto, @ID_Movimientos);
SELECT ID_Inventario, Cantidad, ID_Producto, ID_Movimientos FROM Inventario WHERE (ID_Inventario = @ID_Inventario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Inventario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Inventario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Inventario, Cantidad, ID_Producto, ID_Movimientos FROM dbo.Inventario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Inventario] SET [ID_Inventario] = @ID_Inventario, [Cantidad] = @Cantidad, [ID_Producto] = @ID_Producto, [ID_Movimientos] = @ID_Movimientos WHERE (([ID_Inventario] = @Original_ID_Inventario) AND ((@IsNull_Cantidad = 1 AND [Cantidad] IS NULL) OR ([Cantidad] = @Original_Cantidad)) AND ((@IsNull_ID_Producto = 1 AND [ID_Producto] IS NULL) OR ([ID_Producto] = @Original_ID_Producto)) AND ((@IsNull_ID_Movimientos = 1 AND [ID_Movimientos] IS NULL) OR ([ID_Movimientos] = @Original_ID_Movimientos)));
SELECT ID_Inventario, Cantidad, ID_Producto, ID_Movimientos FROM Inventario WHERE (ID_Inventario = @ID_Inventario)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Inventario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Inventario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Inventario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Inventario" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Inventario" DataSetColumn="ID_Inventario" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
              <Mapping SourceColumn="ID_Producto" DataSetColumn="ID_Producto" />
              <Mapping SourceColumn="ID_Movimientos" DataSetColumn="ID_Movimientos" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LotesTableAdapter" GeneratorDataComponentClassName="LotesTableAdapter" Name="Lotes" UserDataComponentName="LotesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Lotes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Lotes] WHERE (([ID_Lote] = @Original_ID_Lote) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)) AND ((@IsNull_Fecha_Ingreso = 1 AND [Fecha_Ingreso] IS NULL) OR ([Fecha_Ingreso] = @Original_Fecha_Ingreso)) AND ((@IsNull_Fecha_Expiracion = 1 AND [Fecha_Expiracion] IS NULL) OR ([Fecha_Expiracion] = @Original_Fecha_Expiracion)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha_Ingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha_Ingreso" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha_Expiracion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha_Expiracion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Lotes] ([ID_Lote], [Nombre], [Fecha_Ingreso], [Fecha_Expiracion]) VALUES (@ID_Lote, @Nombre, @Fecha_Ingreso, @Fecha_Expiracion);
SELECT ID_Lote, Nombre, Fecha_Ingreso, Fecha_Expiracion FROM Lotes WHERE (ID_Lote = @ID_Lote)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha_Ingreso" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha_Expiracion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Lote, Nombre, Fecha_Ingreso, Fecha_Expiracion FROM dbo.Lotes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Lotes] SET [ID_Lote] = @ID_Lote, [Nombre] = @Nombre, [Fecha_Ingreso] = @Fecha_Ingreso, [Fecha_Expiracion] = @Fecha_Expiracion WHERE (([ID_Lote] = @Original_ID_Lote) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)) AND ((@IsNull_Fecha_Ingreso = 1 AND [Fecha_Ingreso] IS NULL) OR ([Fecha_Ingreso] = @Original_Fecha_Ingreso)) AND ((@IsNull_Fecha_Expiracion = 1 AND [Fecha_Expiracion] IS NULL) OR ([Fecha_Expiracion] = @Original_Fecha_Expiracion)));
SELECT ID_Lote, Nombre, Fecha_Ingreso, Fecha_Expiracion FROM Lotes WHERE (ID_Lote = @ID_Lote)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha_Ingreso" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha_Expiracion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha_Ingreso" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha_Ingreso" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Ingreso" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha_Expiracion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha_Expiracion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha_Expiracion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Lote" DataSetColumn="ID_Lote" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Fecha_Ingreso" DataSetColumn="Fecha_Ingreso" />
              <Mapping SourceColumn="Fecha_Expiracion" DataSetColumn="Fecha_Expiracion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MovimientosTableAdapter" GeneratorDataComponentClassName="MovimientosTableAdapter" Name="Movimientos" UserDataComponentName="MovimientosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Movimientos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Movimientos] WHERE (([ID_Movimientos] = @Original_ID_Movimientos) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_ID_Tipo_Documento = 1 AND [ID_Tipo_Documento] IS NULL) OR ([ID_Tipo_Documento] = @Original_ID_Tipo_Documento)) AND ((@IsNull_ID_Bodega = 1 AND [ID_Bodega] IS NULL) OR ([ID_Bodega] = @Original_ID_Bodega)) AND ((@IsNull_ID_Socio = 1 AND [ID_Socio] IS NULL) OR ([ID_Socio] = @Original_ID_Socio)) AND ((@IsNull_ID_Lote = 1 AND [ID_Lote] IS NULL) OR ([ID_Lote] = @Original_ID_Lote)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Movimientos] ([ID_Movimientos], [Fecha], [Descripcion], [ID_Tipo_Documento], [ID_Bodega], [ID_Socio], [ID_Lote]) VALUES (@ID_Movimientos, @Fecha, @Descripcion, @ID_Tipo_Documento, @ID_Bodega, @ID_Socio, @ID_Lote);
SELECT ID_Movimientos, Fecha, Descripcion, ID_Tipo_Documento, ID_Bodega, ID_Socio, ID_Lote FROM Movimientos WHERE (ID_Movimientos = @ID_Movimientos)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Movimientos, Fecha, Descripcion, ID_Tipo_Documento, ID_Bodega, ID_Socio, ID_Lote FROM dbo.Movimientos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Movimientos] SET [ID_Movimientos] = @ID_Movimientos, [Fecha] = @Fecha, [Descripcion] = @Descripcion, [ID_Tipo_Documento] = @ID_Tipo_Documento, [ID_Bodega] = @ID_Bodega, [ID_Socio] = @ID_Socio, [ID_Lote] = @ID_Lote WHERE (([ID_Movimientos] = @Original_ID_Movimientos) AND ((@IsNull_Fecha = 1 AND [Fecha] IS NULL) OR ([Fecha] = @Original_Fecha)) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)) AND ((@IsNull_ID_Tipo_Documento = 1 AND [ID_Tipo_Documento] IS NULL) OR ([ID_Tipo_Documento] = @Original_ID_Tipo_Documento)) AND ((@IsNull_ID_Bodega = 1 AND [ID_Bodega] IS NULL) OR ([ID_Bodega] = @Original_ID_Bodega)) AND ((@IsNull_ID_Socio = 1 AND [ID_Socio] IS NULL) OR ([ID_Socio] = @Original_ID_Socio)) AND ((@IsNull_ID_Lote = 1 AND [ID_Lote] IS NULL) OR ([ID_Lote] = @Original_ID_Lote)));
SELECT ID_Movimientos, Fecha, Descripcion, ID_Tipo_Documento, ID_Bodega, ID_Socio, ID_Lote FROM Movimientos WHERE (ID_Movimientos = @ID_Movimientos)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Movimientos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Movimientos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fecha" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Lote" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Lote" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Movimientos" DataSetColumn="ID_Movimientos" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="ID_Tipo_Documento" DataSetColumn="ID_Tipo_Documento" />
              <Mapping SourceColumn="ID_Bodega" DataSetColumn="ID_Bodega" />
              <Mapping SourceColumn="ID_Socio" DataSetColumn="ID_Socio" />
              <Mapping SourceColumn="ID_Lote" DataSetColumn="ID_Lote" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductosTableAdapter" GeneratorDataComponentClassName="ProductosTableAdapter" Name="Productos" UserDataComponentName="ProductosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Productos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Productos] WHERE (([ID_Producto] = @Original_ID_Producto) AND ((@IsNull_Nombre_Producto = 1 AND [Nombre_Producto] IS NULL) OR ([Nombre_Producto] = @Original_Nombre_Producto)) AND ((@IsNull_Costo = 1 AND [Costo] IS NULL) OR ([Costo] = @Original_Costo)) AND ((@IsNull_ID_Tipo_Producto = 1 AND [ID_Tipo_Producto] IS NULL) OR ([ID_Tipo_Producto] = @Original_ID_Tipo_Producto)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre_Producto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Productos] ([ID_Producto], [Nombre_Producto], [Costo], [ID_Tipo_Producto]) VALUES (@ID_Producto, @Nombre_Producto, @Costo, @ID_Tipo_Producto);
SELECT ID_Producto, Nombre_Producto, Costo, ID_Tipo_Producto FROM Productos WHERE (ID_Producto = @ID_Producto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre_Producto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Producto, Nombre_Producto, Costo, ID_Tipo_Producto FROM dbo.Productos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Productos] SET [ID_Producto] = @ID_Producto, [Nombre_Producto] = @Nombre_Producto, [Costo] = @Costo, [ID_Tipo_Producto] = @ID_Tipo_Producto WHERE (([ID_Producto] = @Original_ID_Producto) AND ((@IsNull_Nombre_Producto = 1 AND [Nombre_Producto] IS NULL) OR ([Nombre_Producto] = @Original_Nombre_Producto)) AND ((@IsNull_Costo = 1 AND [Costo] IS NULL) OR ([Costo] = @Original_Costo)) AND ((@IsNull_ID_Tipo_Producto = 1 AND [ID_Tipo_Producto] IS NULL) OR ([ID_Tipo_Producto] = @Original_ID_Tipo_Producto)));
SELECT ID_Producto, Nombre_Producto, Costo, ID_Tipo_Producto FROM Productos WHERE (ID_Producto = @ID_Producto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre_Producto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre_Producto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Costo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Costo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Producto" DataSetColumn="ID_Producto" />
              <Mapping SourceColumn="Nombre_Producto" DataSetColumn="Nombre_Producto" />
              <Mapping SourceColumn="Costo" DataSetColumn="Costo" />
              <Mapping SourceColumn="ID_Tipo_Producto" DataSetColumn="ID_Tipo_Producto" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Roles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Roles] WHERE (([ID_Rol] = @Original_ID_Rol) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roles] ([ID_Rol], [Descripcion]) VALUES (@ID_Rol, @Descripcion);
SELECT ID_Rol, Descripcion FROM Roles WHERE (ID_Rol = @ID_Rol)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Rol, Descripcion FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [ID_Rol] = @ID_Rol, [Descripcion] = @Descripcion WHERE (([ID_Rol] = @Original_ID_Rol) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)));
SELECT ID_Rol, Descripcion FROM Roles WHERE (ID_Rol = @ID_Rol)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Rol" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Rol" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Rol" DataSetColumn="ID_Rol" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SocioTableAdapter" GeneratorDataComponentClassName="SocioTableAdapter" Name="Socio" UserDataComponentName="SocioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Socio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Socio] WHERE (([ID_Socio] = @Original_ID_Socio) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Documento = 1 AND [Documento] IS NULL) OR ([Documento] = @Original_Documento)) AND ((@IsNull_Telefono = 1 AND [Telefono] IS NULL) OR ([Telefono] = @Original_Telefono)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_Contacto = 1 AND [Contacto] IS NULL) OR ([Contacto] = @Original_Contacto)) AND ((@IsNull_ID_Tipo_Socio = 1 AND [ID_Tipo_Socio] IS NULL) OR ([ID_Tipo_Socio] = @Original_ID_Tipo_Socio)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Documento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Socio] ([ID_Socio], [Nombre], [Direccion], [Documento], [Telefono], [email], [Contacto], [ID_Tipo_Socio]) VALUES (@ID_Socio, @Nombre, @Direccion, @Documento, @Telefono, @email, @Contacto, @ID_Tipo_Socio);
SELECT ID_Socio, Nombre, Direccion, Documento, Telefono, email, Contacto, ID_Tipo_Socio FROM Socio WHERE (ID_Socio = @ID_Socio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Documento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Socio, Nombre, Direccion, Documento, Telefono, email, Contacto, ID_Tipo_Socio FROM dbo.Socio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Socio] SET [ID_Socio] = @ID_Socio, [Nombre] = @Nombre, [Direccion] = @Direccion, [Documento] = @Documento, [Telefono] = @Telefono, [email] = @email, [Contacto] = @Contacto, [ID_Tipo_Socio] = @ID_Tipo_Socio WHERE (([ID_Socio] = @Original_ID_Socio) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Documento = 1 AND [Documento] IS NULL) OR ([Documento] = @Original_Documento)) AND ((@IsNull_Telefono = 1 AND [Telefono] IS NULL) OR ([Telefono] = @Original_Telefono)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_Contacto = 1 AND [Contacto] IS NULL) OR ([Contacto] = @Original_Contacto)) AND ((@IsNull_ID_Tipo_Socio = 1 AND [ID_Tipo_Socio] IS NULL) OR ([ID_Tipo_Socio] = @Original_ID_Tipo_Socio)));
SELECT ID_Socio, Nombre, Direccion, Documento, Telefono, email, Contacto, ID_Tipo_Socio FROM Socio WHERE (ID_Socio = @ID_Socio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Documento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Contacto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Documento" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Contacto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Contacto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Contacto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Socio" DataSetColumn="ID_Socio" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Direccion" DataSetColumn="Direccion" />
              <Mapping SourceColumn="Documento" DataSetColumn="Documento" />
              <Mapping SourceColumn="Telefono" DataSetColumn="Telefono" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="Contacto" DataSetColumn="Contacto" />
              <Mapping SourceColumn="ID_Tipo_Socio" DataSetColumn="ID_Tipo_Socio" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tipo_BodegaTableAdapter" GeneratorDataComponentClassName="Tipo_BodegaTableAdapter" Name="Tipo_Bodega" UserDataComponentName="Tipo_BodegaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Tipo_Bodega" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tipo_Bodega] WHERE (([ID_Tipo_Bodega] = @Original_ID_Tipo_Bodega) AND ((@IsNull_Nombre_Bodega = 1 AND [Nombre_Bodega] IS NULL) OR ([Nombre_Bodega] = @Original_Nombre_Bodega)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre_Bodega" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tipo_Bodega] ([ID_Tipo_Bodega], [Nombre_Bodega]) VALUES (@ID_Tipo_Bodega, @Nombre_Bodega);
SELECT ID_Tipo_Bodega, Nombre_Bodega FROM Tipo_Bodega WHERE (ID_Tipo_Bodega = @ID_Tipo_Bodega)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre_Bodega" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tipo_Bodega, Nombre_Bodega FROM dbo.Tipo_Bodega</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tipo_Bodega] SET [ID_Tipo_Bodega] = @ID_Tipo_Bodega, [Nombre_Bodega] = @Nombre_Bodega WHERE (([ID_Tipo_Bodega] = @Original_ID_Tipo_Bodega) AND ((@IsNull_Nombre_Bodega = 1 AND [Nombre_Bodega] IS NULL) OR ([Nombre_Bodega] = @Original_Nombre_Bodega)));
SELECT ID_Tipo_Bodega, Nombre_Bodega FROM Tipo_Bodega WHERE (ID_Tipo_Bodega = @ID_Tipo_Bodega)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombre_Bodega" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre_Bodega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombre_Bodega" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombre_Bodega" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Tipo_Bodega" DataSetColumn="ID_Tipo_Bodega" />
              <Mapping SourceColumn="Nombre_Bodega" DataSetColumn="Nombre_Bodega" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tipo_DocumentoTableAdapter" GeneratorDataComponentClassName="Tipo_DocumentoTableAdapter" Name="Tipo_Documento" UserDataComponentName="Tipo_DocumentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Tipo_Documento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tipo_Documento] WHERE (([ID_Tipo_Documento] = @Original_ID_Tipo_Documento) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tipo_Documento] ([ID_Tipo_Documento], [Tipo]) VALUES (@ID_Tipo_Documento, @Tipo);
SELECT ID_Tipo_Documento, Tipo FROM Tipo_Documento WHERE (ID_Tipo_Documento = @ID_Tipo_Documento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tipo_Documento, Tipo FROM dbo.Tipo_Documento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tipo_Documento] SET [ID_Tipo_Documento] = @ID_Tipo_Documento, [Tipo] = @Tipo WHERE (([ID_Tipo_Documento] = @Original_ID_Tipo_Documento) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)));
SELECT ID_Tipo_Documento, Tipo FROM Tipo_Documento WHERE (ID_Tipo_Documento = @ID_Tipo_Documento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Documento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Documento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Tipo_Documento" DataSetColumn="ID_Tipo_Documento" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tipo_ProductoTableAdapter" GeneratorDataComponentClassName="Tipo_ProductoTableAdapter" Name="Tipo_Producto" UserDataComponentName="Tipo_ProductoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Tipo_Producto" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tipo_Producto] WHERE (([ID_Tipo_Producto] = @Original_ID_Tipo_Producto) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tipo_Producto] ([ID_Tipo_Producto], [Descripcion]) VALUES (@ID_Tipo_Producto, @Descripcion);
SELECT ID_Tipo_Producto, Descripcion FROM Tipo_Producto WHERE (ID_Tipo_Producto = @ID_Tipo_Producto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tipo_Producto, Descripcion FROM dbo.Tipo_Producto</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tipo_Producto] SET [ID_Tipo_Producto] = @ID_Tipo_Producto, [Descripcion] = @Descripcion WHERE (([ID_Tipo_Producto] = @Original_ID_Tipo_Producto) AND ((@IsNull_Descripcion = 1 AND [Descripcion] IS NULL) OR ([Descripcion] = @Original_Descripcion)));
SELECT ID_Tipo_Producto, Descripcion FROM Tipo_Producto WHERE (ID_Tipo_Producto = @ID_Tipo_Producto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Producto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Producto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descripcion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Tipo_Producto" DataSetColumn="ID_Tipo_Producto" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tipo_SocioTableAdapter" GeneratorDataComponentClassName="Tipo_SocioTableAdapter" Name="Tipo_Socio" UserDataComponentName="Tipo_SocioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="INVE_FISHConnectionString (MySettings)" DbObjectName="INVE_FISH.dbo.Tipo_Socio" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tipo_Socio] WHERE (([ID_Tipo_Socio] = @Original_ID_Tipo_Socio) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tipo_Socio] ([ID_Tipo_Socio], [Tipo]) VALUES (@ID_Tipo_Socio, @Tipo);
SELECT ID_Tipo_Socio, Tipo FROM Tipo_Socio WHERE (ID_Tipo_Socio = @ID_Tipo_Socio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Tipo_Socio, Tipo FROM dbo.Tipo_Socio</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tipo_Socio] SET [ID_Tipo_Socio] = @ID_Tipo_Socio, [Tipo] = @Tipo WHERE (([ID_Tipo_Socio] = @Original_ID_Tipo_Socio) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)));
SELECT ID_Tipo_Socio, Tipo FROM Tipo_Socio WHERE (ID_Tipo_Socio = @ID_Tipo_Socio)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Tipo_Socio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Tipo_Socio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Tipo_Socio" DataSetColumn="ID_Tipo_Socio" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="INVE_FISHDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="INVE_FISHDataSet" msprop:Generator_UserDSName="INVE_FISHDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Acceso" msprop:Generator_TableClassName="AccesoDataTable" msprop:Generator_TableVarName="tableAcceso" msprop:Generator_TablePropName="Acceso" msprop:Generator_RowDeletingName="AccesoRowDeleting" msprop:Generator_RowChangingName="AccesoRowChanging" msprop:Generator_RowEvHandlerName="AccesoRowChangeEventHandler" msprop:Generator_RowDeletedName="AccesoRowDeleted" msprop:Generator_UserTableName="Acceso" msprop:Generator_RowChangedName="AccesoRowChanged" msprop:Generator_RowEvArgName="AccesoRowChangeEvent" msprop:Generator_RowClassName="AccesoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Usuario" msprop:Generator_ColumnVarNameInTable="columnID_Usuario" msprop:Generator_ColumnPropNameInRow="ID_Usuario" msprop:Generator_ColumnPropNameInTable="ID_UsuarioColumn" msprop:Generator_UserColumnName="ID_Usuario" type="xs:int" />
              <xs:element name="Usuario" msprop:Generator_ColumnVarNameInTable="columnUsuario" msprop:Generator_ColumnPropNameInRow="Usuario" msprop:Generator_ColumnPropNameInTable="UsuarioColumn" msprop:Generator_UserColumnName="Usuario" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contrasenia" msprop:Generator_ColumnVarNameInTable="columnContrasenia" msprop:Generator_ColumnPropNameInRow="Contrasenia" msprop:Generator_ColumnPropNameInTable="ContraseniaColumn" msprop:Generator_UserColumnName="Contrasenia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Rol" msprop:Generator_ColumnVarNameInTable="columnID_Rol" msprop:Generator_ColumnPropNameInRow="ID_Rol" msprop:Generator_ColumnPropNameInTable="ID_RolColumn" msprop:Generator_UserColumnName="ID_Rol" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Bodegas" msprop:Generator_TableClassName="BodegasDataTable" msprop:Generator_TableVarName="tableBodegas" msprop:Generator_TablePropName="Bodegas" msprop:Generator_RowDeletingName="BodegasRowDeleting" msprop:Generator_RowChangingName="BodegasRowChanging" msprop:Generator_RowEvHandlerName="BodegasRowChangeEventHandler" msprop:Generator_RowDeletedName="BodegasRowDeleted" msprop:Generator_UserTableName="Bodegas" msprop:Generator_RowChangedName="BodegasRowChanged" msprop:Generator_RowEvArgName="BodegasRowChangeEvent" msprop:Generator_RowClassName="BodegasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Bodega" msprop:Generator_ColumnVarNameInTable="columnID_Bodega" msprop:Generator_ColumnPropNameInRow="ID_Bodega" msprop:Generator_ColumnPropNameInTable="ID_BodegaColumn" msprop:Generator_UserColumnName="ID_Bodega" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Tipo_Bodega" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Bodega" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Bodega" msprop:Generator_ColumnPropNameInTable="ID_Tipo_BodegaColumn" msprop:Generator_UserColumnName="ID_Tipo_Bodega" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Inventario" msprop:Generator_TableClassName="InventarioDataTable" msprop:Generator_TableVarName="tableInventario" msprop:Generator_TablePropName="Inventario" msprop:Generator_RowDeletingName="InventarioRowDeleting" msprop:Generator_RowChangingName="InventarioRowChanging" msprop:Generator_RowEvHandlerName="InventarioRowChangeEventHandler" msprop:Generator_RowDeletedName="InventarioRowDeleted" msprop:Generator_UserTableName="Inventario" msprop:Generator_RowChangedName="InventarioRowChanged" msprop:Generator_RowEvArgName="InventarioRowChangeEvent" msprop:Generator_RowClassName="InventarioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Inventario" msprop:Generator_ColumnVarNameInTable="columnID_Inventario" msprop:Generator_ColumnPropNameInRow="ID_Inventario" msprop:Generator_ColumnPropNameInTable="ID_InventarioColumn" msprop:Generator_UserColumnName="ID_Inventario" type="xs:int" />
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Producto" msprop:Generator_ColumnVarNameInTable="columnID_Producto" msprop:Generator_ColumnPropNameInRow="ID_Producto" msprop:Generator_ColumnPropNameInTable="ID_ProductoColumn" msprop:Generator_UserColumnName="ID_Producto" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Movimientos" msprop:Generator_ColumnVarNameInTable="columnID_Movimientos" msprop:Generator_ColumnPropNameInRow="ID_Movimientos" msprop:Generator_ColumnPropNameInTable="ID_MovimientosColumn" msprop:Generator_UserColumnName="ID_Movimientos" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Lotes" msprop:Generator_TableClassName="LotesDataTable" msprop:Generator_TableVarName="tableLotes" msprop:Generator_TablePropName="Lotes" msprop:Generator_RowDeletingName="LotesRowDeleting" msprop:Generator_RowChangingName="LotesRowChanging" msprop:Generator_RowEvHandlerName="LotesRowChangeEventHandler" msprop:Generator_RowDeletedName="LotesRowDeleted" msprop:Generator_UserTableName="Lotes" msprop:Generator_RowChangedName="LotesRowChanged" msprop:Generator_RowEvArgName="LotesRowChangeEvent" msprop:Generator_RowClassName="LotesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Lote" msprop:Generator_ColumnVarNameInTable="columnID_Lote" msprop:Generator_ColumnPropNameInRow="ID_Lote" msprop:Generator_ColumnPropNameInTable="ID_LoteColumn" msprop:Generator_UserColumnName="ID_Lote" type="xs:int" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha_Ingreso" msprop:Generator_ColumnVarNameInTable="columnFecha_Ingreso" msprop:Generator_ColumnPropNameInRow="Fecha_Ingreso" msprop:Generator_ColumnPropNameInTable="Fecha_IngresoColumn" msprop:Generator_UserColumnName="Fecha_Ingreso" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha_Expiracion" msprop:Generator_ColumnVarNameInTable="columnFecha_Expiracion" msprop:Generator_ColumnPropNameInRow="Fecha_Expiracion" msprop:Generator_ColumnPropNameInTable="Fecha_ExpiracionColumn" msprop:Generator_UserColumnName="Fecha_Expiracion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Movimientos" msprop:Generator_TableClassName="MovimientosDataTable" msprop:Generator_TableVarName="tableMovimientos" msprop:Generator_TablePropName="Movimientos" msprop:Generator_RowDeletingName="MovimientosRowDeleting" msprop:Generator_RowChangingName="MovimientosRowChanging" msprop:Generator_RowEvHandlerName="MovimientosRowChangeEventHandler" msprop:Generator_RowDeletedName="MovimientosRowDeleted" msprop:Generator_UserTableName="Movimientos" msprop:Generator_RowChangedName="MovimientosRowChanged" msprop:Generator_RowEvArgName="MovimientosRowChangeEvent" msprop:Generator_RowClassName="MovimientosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Movimientos" msprop:Generator_ColumnVarNameInTable="columnID_Movimientos" msprop:Generator_ColumnPropNameInRow="ID_Movimientos" msprop:Generator_ColumnPropNameInTable="ID_MovimientosColumn" msprop:Generator_UserColumnName="ID_Movimientos" type="xs:int" />
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Tipo_Documento" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Documento" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Documento" msprop:Generator_ColumnPropNameInTable="ID_Tipo_DocumentoColumn" msprop:Generator_UserColumnName="ID_Tipo_Documento" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Bodega" msprop:Generator_ColumnVarNameInTable="columnID_Bodega" msprop:Generator_ColumnPropNameInRow="ID_Bodega" msprop:Generator_ColumnPropNameInTable="ID_BodegaColumn" msprop:Generator_UserColumnName="ID_Bodega" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Socio" msprop:Generator_ColumnVarNameInTable="columnID_Socio" msprop:Generator_ColumnPropNameInRow="ID_Socio" msprop:Generator_ColumnPropNameInTable="ID_SocioColumn" msprop:Generator_UserColumnName="ID_Socio" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Lote" msprop:Generator_ColumnVarNameInTable="columnID_Lote" msprop:Generator_ColumnPropNameInRow="ID_Lote" msprop:Generator_ColumnPropNameInTable="ID_LoteColumn" msprop:Generator_UserColumnName="ID_Lote" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Productos" msprop:Generator_TableClassName="ProductosDataTable" msprop:Generator_TableVarName="tableProductos" msprop:Generator_TablePropName="Productos" msprop:Generator_RowDeletingName="ProductosRowDeleting" msprop:Generator_RowChangingName="ProductosRowChanging" msprop:Generator_RowEvHandlerName="ProductosRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductosRowDeleted" msprop:Generator_UserTableName="Productos" msprop:Generator_RowChangedName="ProductosRowChanged" msprop:Generator_RowEvArgName="ProductosRowChangeEvent" msprop:Generator_RowClassName="ProductosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Producto" msprop:Generator_ColumnVarNameInTable="columnID_Producto" msprop:Generator_ColumnPropNameInRow="ID_Producto" msprop:Generator_ColumnPropNameInTable="ID_ProductoColumn" msprop:Generator_UserColumnName="ID_Producto" type="xs:int" />
              <xs:element name="Nombre_Producto" msprop:Generator_ColumnVarNameInTable="columnNombre_Producto" msprop:Generator_ColumnPropNameInRow="Nombre_Producto" msprop:Generator_ColumnPropNameInTable="Nombre_ProductoColumn" msprop:Generator_UserColumnName="Nombre_Producto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Costo" msprop:Generator_ColumnVarNameInTable="columnCosto" msprop:Generator_ColumnPropNameInRow="Costo" msprop:Generator_ColumnPropNameInTable="CostoColumn" msprop:Generator_UserColumnName="Costo" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Tipo_Producto" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Producto" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Producto" msprop:Generator_ColumnPropNameInTable="ID_Tipo_ProductoColumn" msprop:Generator_UserColumnName="ID_Tipo_Producto" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_TableVarName="tableRoles" msprop:Generator_TablePropName="Roles" msprop:Generator_RowDeletingName="RolesRowDeleting" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_UserTableName="Roles" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_RowEvArgName="RolesRowChangeEvent" msprop:Generator_RowClassName="RolesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Rol" msprop:Generator_ColumnVarNameInTable="columnID_Rol" msprop:Generator_ColumnPropNameInRow="ID_Rol" msprop:Generator_ColumnPropNameInTable="ID_RolColumn" msprop:Generator_UserColumnName="ID_Rol" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Socio" msprop:Generator_TableClassName="SocioDataTable" msprop:Generator_TableVarName="tableSocio" msprop:Generator_TablePropName="Socio" msprop:Generator_RowDeletingName="SocioRowDeleting" msprop:Generator_RowChangingName="SocioRowChanging" msprop:Generator_RowEvHandlerName="SocioRowChangeEventHandler" msprop:Generator_RowDeletedName="SocioRowDeleted" msprop:Generator_UserTableName="Socio" msprop:Generator_RowChangedName="SocioRowChanged" msprop:Generator_RowEvArgName="SocioRowChangeEvent" msprop:Generator_RowClassName="SocioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Socio" msprop:Generator_ColumnVarNameInTable="columnID_Socio" msprop:Generator_ColumnPropNameInRow="ID_Socio" msprop:Generator_ColumnPropNameInTable="ID_SocioColumn" msprop:Generator_UserColumnName="ID_Socio" type="xs:int" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Direccion" msprop:Generator_ColumnVarNameInTable="columnDireccion" msprop:Generator_ColumnPropNameInRow="Direccion" msprop:Generator_ColumnPropNameInTable="DireccionColumn" msprop:Generator_UserColumnName="Direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Documento" msprop:Generator_ColumnVarNameInTable="columnDocumento" msprop:Generator_ColumnPropNameInRow="Documento" msprop:Generator_ColumnPropNameInTable="DocumentoColumn" msprop:Generator_UserColumnName="Documento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefono" msprop:Generator_ColumnVarNameInTable="columnTelefono" msprop:Generator_ColumnPropNameInRow="Telefono" msprop:Generator_ColumnPropNameInTable="TelefonoColumn" msprop:Generator_UserColumnName="Telefono" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contacto" msprop:Generator_ColumnVarNameInTable="columnContacto" msprop:Generator_ColumnPropNameInRow="Contacto" msprop:Generator_ColumnPropNameInTable="ContactoColumn" msprop:Generator_UserColumnName="Contacto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Tipo_Socio" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Socio" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Socio" msprop:Generator_ColumnPropNameInTable="ID_Tipo_SocioColumn" msprop:Generator_UserColumnName="ID_Tipo_Socio" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tipo_Bodega" msprop:Generator_TableClassName="Tipo_BodegaDataTable" msprop:Generator_TableVarName="tableTipo_Bodega" msprop:Generator_TablePropName="Tipo_Bodega" msprop:Generator_RowDeletingName="Tipo_BodegaRowDeleting" msprop:Generator_RowChangingName="Tipo_BodegaRowChanging" msprop:Generator_RowEvHandlerName="Tipo_BodegaRowChangeEventHandler" msprop:Generator_RowDeletedName="Tipo_BodegaRowDeleted" msprop:Generator_UserTableName="Tipo_Bodega" msprop:Generator_RowChangedName="Tipo_BodegaRowChanged" msprop:Generator_RowEvArgName="Tipo_BodegaRowChangeEvent" msprop:Generator_RowClassName="Tipo_BodegaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Tipo_Bodega" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Bodega" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Bodega" msprop:Generator_ColumnPropNameInTable="ID_Tipo_BodegaColumn" msprop:Generator_UserColumnName="ID_Tipo_Bodega" type="xs:int" />
              <xs:element name="Nombre_Bodega" msprop:Generator_ColumnVarNameInTable="columnNombre_Bodega" msprop:Generator_ColumnPropNameInRow="Nombre_Bodega" msprop:Generator_ColumnPropNameInTable="Nombre_BodegaColumn" msprop:Generator_UserColumnName="Nombre_Bodega" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tipo_Documento" msprop:Generator_TableClassName="Tipo_DocumentoDataTable" msprop:Generator_TableVarName="tableTipo_Documento" msprop:Generator_TablePropName="Tipo_Documento" msprop:Generator_RowDeletingName="Tipo_DocumentoRowDeleting" msprop:Generator_RowChangingName="Tipo_DocumentoRowChanging" msprop:Generator_RowEvHandlerName="Tipo_DocumentoRowChangeEventHandler" msprop:Generator_RowDeletedName="Tipo_DocumentoRowDeleted" msprop:Generator_UserTableName="Tipo_Documento" msprop:Generator_RowChangedName="Tipo_DocumentoRowChanged" msprop:Generator_RowEvArgName="Tipo_DocumentoRowChangeEvent" msprop:Generator_RowClassName="Tipo_DocumentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Tipo_Documento" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Documento" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Documento" msprop:Generator_ColumnPropNameInTable="ID_Tipo_DocumentoColumn" msprop:Generator_UserColumnName="ID_Tipo_Documento" type="xs:int" />
              <xs:element name="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" msprop:Generator_UserColumnName="Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tipo_Producto" msprop:Generator_TableClassName="Tipo_ProductoDataTable" msprop:Generator_TableVarName="tableTipo_Producto" msprop:Generator_TablePropName="Tipo_Producto" msprop:Generator_RowDeletingName="Tipo_ProductoRowDeleting" msprop:Generator_RowChangingName="Tipo_ProductoRowChanging" msprop:Generator_RowEvHandlerName="Tipo_ProductoRowChangeEventHandler" msprop:Generator_RowDeletedName="Tipo_ProductoRowDeleted" msprop:Generator_UserTableName="Tipo_Producto" msprop:Generator_RowChangedName="Tipo_ProductoRowChanged" msprop:Generator_RowEvArgName="Tipo_ProductoRowChangeEvent" msprop:Generator_RowClassName="Tipo_ProductoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Tipo_Producto" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Producto" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Producto" msprop:Generator_ColumnPropNameInTable="ID_Tipo_ProductoColumn" msprop:Generator_UserColumnName="ID_Tipo_Producto" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tipo_Socio" msprop:Generator_TableClassName="Tipo_SocioDataTable" msprop:Generator_TableVarName="tableTipo_Socio" msprop:Generator_TablePropName="Tipo_Socio" msprop:Generator_RowDeletingName="Tipo_SocioRowDeleting" msprop:Generator_RowChangingName="Tipo_SocioRowChanging" msprop:Generator_RowEvHandlerName="Tipo_SocioRowChangeEventHandler" msprop:Generator_RowDeletedName="Tipo_SocioRowDeleted" msprop:Generator_UserTableName="Tipo_Socio" msprop:Generator_RowChangedName="Tipo_SocioRowChanged" msprop:Generator_RowEvArgName="Tipo_SocioRowChangeEvent" msprop:Generator_RowClassName="Tipo_SocioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Tipo_Socio" msprop:Generator_ColumnVarNameInTable="columnID_Tipo_Socio" msprop:Generator_ColumnPropNameInRow="ID_Tipo_Socio" msprop:Generator_ColumnPropNameInTable="ID_Tipo_SocioColumn" msprop:Generator_UserColumnName="ID_Tipo_Socio" type="xs:int" />
              <xs:element name="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" msprop:Generator_UserColumnName="Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Acceso" />
      <xs:field xpath="mstns:ID_Usuario" />
    </xs:unique>
    <xs:unique name="Bodegas_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Bodegas" />
      <xs:field xpath="mstns:ID_Bodega" />
    </xs:unique>
    <xs:unique name="Inventario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Inventario" />
      <xs:field xpath="mstns:ID_Inventario" />
    </xs:unique>
    <xs:unique name="Lotes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Lotes" />
      <xs:field xpath="mstns:ID_Lote" />
    </xs:unique>
    <xs:unique name="Movimientos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Movimientos" />
      <xs:field xpath="mstns:ID_Movimientos" />
    </xs:unique>
    <xs:unique name="Productos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Productos" />
      <xs:field xpath="mstns:ID_Producto" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:ID_Rol" />
    </xs:unique>
    <xs:unique name="Socio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Socio" />
      <xs:field xpath="mstns:ID_Socio" />
    </xs:unique>
    <xs:unique name="Tipo_Bodega_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tipo_Bodega" />
      <xs:field xpath="mstns:ID_Tipo_Bodega" />
    </xs:unique>
    <xs:unique name="Tipo_Documento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tipo_Documento" />
      <xs:field xpath="mstns:ID_Tipo_Documento" />
    </xs:unique>
    <xs:unique name="Tipo_Producto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tipo_Producto" />
      <xs:field xpath="mstns:ID_Tipo_Producto" />
    </xs:unique>
    <xs:unique name="Tipo_Socio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tipo_Socio" />
      <xs:field xpath="mstns:ID_Tipo_Socio" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="fk_tipo_rol" msdata:parent="Roles" msdata:child="Acceso" msdata:parentkey="ID_Rol" msdata:childkey="ID_Rol" msprop:Generator_UserChildTable="Acceso" msprop:Generator_ChildPropName="GetAccesoRows" msprop:Generator_UserRelationName="fk_tipo_rol" msprop:Generator_RelationVarName="relationfk_tipo_rol" msprop:Generator_UserParentTable="Roles" msprop:Generator_ParentPropName="RolesRow" />
      <msdata:Relationship name="FK_Tipo_Bodega" msdata:parent="Tipo_Bodega" msdata:child="Bodegas" msdata:parentkey="ID_Tipo_Bodega" msdata:childkey="ID_Tipo_Bodega" msprop:Generator_UserChildTable="Bodegas" msprop:Generator_ChildPropName="GetBodegasRows" msprop:Generator_UserRelationName="FK_Tipo_Bodega" msprop:Generator_RelationVarName="relationFK_Tipo_Bodega" msprop:Generator_UserParentTable="Tipo_Bodega" msprop:Generator_ParentPropName="Tipo_BodegaRow" />
      <msdata:Relationship name="FK_Movimientos" msdata:parent="Movimientos" msdata:child="Inventario" msdata:parentkey="ID_Movimientos" msdata:childkey="ID_Movimientos" msprop:Generator_UserChildTable="Inventario" msprop:Generator_ChildPropName="GetInventarioRows" msprop:Generator_UserRelationName="FK_Movimientos" msprop:Generator_RelationVarName="relationFK_Movimientos" msprop:Generator_UserParentTable="Movimientos" msprop:Generator_ParentPropName="MovimientosRow" />
      <msdata:Relationship name="FK_Producto" msdata:parent="Productos" msdata:child="Inventario" msdata:parentkey="ID_Producto" msdata:childkey="ID_Producto" msprop:Generator_UserChildTable="Inventario" msprop:Generator_ChildPropName="GetInventarioRows" msprop:Generator_UserRelationName="FK_Producto" msprop:Generator_RelationVarName="relationFK_Producto" msprop:Generator_UserParentTable="Productos" msprop:Generator_ParentPropName="ProductosRow" />
      <msdata:Relationship name="FK_Bodega" msdata:parent="Bodegas" msdata:child="Movimientos" msdata:parentkey="ID_Bodega" msdata:childkey="ID_Bodega" msprop:Generator_UserChildTable="Movimientos" msprop:Generator_ChildPropName="GetMovimientosRows" msprop:Generator_UserRelationName="FK_Bodega" msprop:Generator_ParentPropName="BodegasRow" msprop:Generator_RelationVarName="relationFK_Bodega" msprop:Generator_UserParentTable="Bodegas" />
      <msdata:Relationship name="FK_Lote" msdata:parent="Lotes" msdata:child="Movimientos" msdata:parentkey="ID_Lote" msdata:childkey="ID_Lote" msprop:Generator_UserChildTable="Movimientos" msprop:Generator_ChildPropName="GetMovimientosRows" msprop:Generator_UserRelationName="FK_Lote" msprop:Generator_ParentPropName="LotesRow" msprop:Generator_RelationVarName="relationFK_Lote" msprop:Generator_UserParentTable="Lotes" />
      <msdata:Relationship name="FK_Socio" msdata:parent="Socio" msdata:child="Movimientos" msdata:parentkey="ID_Socio" msdata:childkey="ID_Socio" msprop:Generator_UserChildTable="Movimientos" msprop:Generator_ChildPropName="GetMovimientosRows" msprop:Generator_UserRelationName="FK_Socio" msprop:Generator_RelationVarName="relationFK_Socio" msprop:Generator_UserParentTable="Socio" msprop:Generator_ParentPropName="SocioRow" />
      <msdata:Relationship name="FK_Tipo_Documento" msdata:parent="Tipo_Documento" msdata:child="Movimientos" msdata:parentkey="ID_Tipo_Documento" msdata:childkey="ID_Tipo_Documento" msprop:Generator_UserChildTable="Movimientos" msprop:Generator_ChildPropName="GetMovimientosRows" msprop:Generator_UserRelationName="FK_Tipo_Documento" msprop:Generator_RelationVarName="relationFK_Tipo_Documento" msprop:Generator_UserParentTable="Tipo_Documento" msprop:Generator_ParentPropName="Tipo_DocumentoRow" />
      <msdata:Relationship name="FK_Tipo_Producto" msdata:parent="Tipo_Producto" msdata:child="Productos" msdata:parentkey="ID_Tipo_Producto" msdata:childkey="ID_Tipo_Producto" msprop:Generator_UserChildTable="Productos" msprop:Generator_ChildPropName="GetProductosRows" msprop:Generator_UserRelationName="FK_Tipo_Producto" msprop:Generator_RelationVarName="relationFK_Tipo_Producto" msprop:Generator_UserParentTable="Tipo_Producto" msprop:Generator_ParentPropName="Tipo_ProductoRow" />
      <msdata:Relationship name="FK_Tipo_Socio" msdata:parent="Tipo_Socio" msdata:child="Socio" msdata:parentkey="ID_Tipo_Socio" msdata:childkey="ID_Tipo_Socio" msprop:Generator_UserChildTable="Socio" msprop:Generator_ChildPropName="GetSocioRows" msprop:Generator_UserRelationName="FK_Tipo_Socio" msprop:Generator_RelationVarName="relationFK_Tipo_Socio" msprop:Generator_UserParentTable="Tipo_Socio" msprop:Generator_ParentPropName="Tipo_SocioRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>